﻿CREATE TABLE [dbo].[FC_SegmentPL] (
    [IdSegmentPL]   INT          IDENTITY (1, 1) NOT NULL,
    [IdSegment]     INT          NULL,
    [IdProductLine] INT          NULL,
    [ICP_Number]    VARCHAR (10) NULL,
    [IdEntityF]     INT          NULL,
    [Year]          INT          NULL,
    CONSTRAINT [PK_FC_Segment] PRIMARY KEY CLUSTERED ([IdSegmentPL] ASC),
    CONSTRAINT [FK_FC_Segment_FC_Entity] FOREIGN KEY ([IdEntityF]) REFERENCES [dbo].[FC_Entity] ([IdEntityF]),
    CONSTRAINT [FK_FC_SegmentPL_FC_ProductLine] FOREIGN KEY ([IdProductLine]) REFERENCES [dbo].[FC_ProductLine] ([IdProductLine]),
    CONSTRAINT [FK_FC_SegmentPL_FC_Segment] FOREIGN KEY ([IdSegment]) REFERENCES [dbo].[FC_Segment] ([IdSegment])
);



